Chicago Sidewalk Cafe Permits

Dataset statistics

Number of variables	22
Number of observations	20116
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	3.4 MiB
Average record size in memory	176.0 B

Variable types

Numeric	10
Text	5
DateTime	3
Categorical	4

Alerts

`city` has constant value ""	Constant
`state` has constant value ""	Constant
`address_number_start` is highly overall correlated with `address_number` and 3 other fields	High correlation
`address_number` is highly overall correlated with `address_number_start` and 3 other fields	High correlation
`ward` is highly overall correlated with `police_district`	High correlation
`police_district` is highly overall correlated with `address_number_start` and 3 other fields	High correlation
`latitude` is highly overall correlated with `address_number_start` and 3 other fields	High correlation
`longitude` is highly overall correlated with `address_number_start` and 2 other fields	High correlation
`street_type` is highly imbalanced (52.2%)	Imbalance
`permit_number` has unique values	Unique
`address_number_start` has 1239 (6.2%) zeros	Zeros
`address_number` has 1239 (6.2%) zeros	Zeros

Reproduction

Analysis started	2023-11-01 23:48:09.888957
Analysis finished	2023-11-01 23:48:31.097586
Duration	21.21 seconds
Software version	ydata-profiling vv4.6.1
Download configuration	config.json

permit_number
Real number (ℝ)

UNIQUE

Distinct	20116
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1153930.9

Minimum	1000571
Maximum	1862206
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	157.3 KiB

Quantile statistics

Minimum	1000571
5-th percentile	1024771
Q1	1074657.5
median	1106724.5
Q3	1131947.2
95-th percentile	1647862.5
Maximum	1862206
Range	861635
Interquartile range (IQR)	57289.75

Descriptive statistics

Standard deviation	180136.64
Coefficient of variation (CV)	0.15610696
Kurtosis	5.2604434
Mean	1153930.9
Median Absolute Deviation (MAD)	25653
Skewness	2.5378187
Sum	2.3212474 × 10¹⁰
Variance	3.244921 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1556602	1	< 0.1%
1087124	1	< 0.1%
1087156	1	< 0.1%
1087150	1	< 0.1%
1087149	1	< 0.1%
1087146	1	< 0.1%
1087144	1	< 0.1%
1087143	1	< 0.1%
1087133	1	< 0.1%
1087122	1	< 0.1%
Other values (20106)	20106	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1000571	1	< 0.1%
1001307	1	< 0.1%
1002652	1	< 0.1%
1002993	1	< 0.1%
1003612	1	< 0.1%
1004393	1	< 0.1%
1007248	1	< 0.1%
1007265	1	< 0.1%
1007306	1	< 0.1%
1007406	1	< 0.1%

Value	Count	Frequency (%)
1862206	1	< 0.1%
1860048	1	< 0.1%
1855208	1	< 0.1%
1854101	1	< 0.1%
1852797	1	< 0.1%
1848630	1	< 0.1%
1848204	1	< 0.1%
1846561	1	< 0.1%
1845400	1	< 0.1%
1844680	1	< 0.1%

account_number
Real number (ℝ)

Distinct	3017
Distinct (%)	15.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	205950.64

Minimum	12
Maximum	495456
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	157.3 KiB

Quantile statistics

Minimum	12
5-th percentile	5350
Q1	23077
median	254059
Q3	348401
95-th percentile	414151
Maximum	495456
Range	495444
Interquartile range (IQR)	325324

Descriptive statistics

Standard deviation	156278.37
Coefficient of variation (CV)	0.75881471
Kurtosis	-1.6005292
Mean	205950.64
Median Absolute Deviation (MAD)	144576
Skewness	-0.0770493
Sum	4.142903 × 10⁹
Variance	2.442293 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
63414	886	4.4%
65004	312	1.6%
298727	114	0.6%
50161	85	0.4%
22633	66	0.3%
369504	64	0.3%
230211	61	0.3%
267891	48	0.2%
66022	45	0.2%
17658	44	0.2%
Other values (3007)	18391	91.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
12	6	< 0.1%
13	21	0.1%
16	4	< 0.1%
27	4	< 0.1%
28	11	0.1%
46	18	0.1%
51	6	< 0.1%
67	20	0.1%
73	17	0.1%
82	2	< 0.1%

Value	Count	Frequency (%)
495456	1	< 0.1%
494737	1	< 0.1%
494267	1	< 0.1%
493688	1	< 0.1%
493621	1	< 0.1%
493348	1	< 0.1%
493334	1	< 0.1%
493192	1	< 0.1%
493107	1	< 0.1%
493069	1	< 0.1%

site_number
Real number (ℝ)

Distinct	100
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.3763671

Minimum	1
Maximum	230
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	157.3 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	2
95-th percentile	23
Maximum	230
Range	229
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	18.124777
Coefficient of variation (CV)	3.3711942
Kurtosis	41.239485
Mean	5.3763671
Median Absolute Deviation (MAD)	0
Skewness	5.9841774
Sum	108151
Variance	328.50756
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	14713	73.1%
2	2297	11.4%
3	608	3.0%
4	287	1.4%
5	210	1.0%
7	121	0.6%
6	106	0.5%
11	98	0.5%
12	94	0.5%
19	91	0.5%
Other values (90)	1491	7.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	14713	73.1%
2	2297	11.4%
3	608	3.0%
4	287	1.4%
5	210	1.0%
6	106	0.5%
7	121	0.6%
8	65	0.3%
9	63	0.3%
10	67	0.3%

Value	Count	Frequency (%)
230	1	< 0.1%
229	1	< 0.1%
228	1	< 0.1%
226	1	< 0.1%
225	1	< 0.1%
224	1	< 0.1%
221	1	< 0.1%
218	1	< 0.1%
217	1	< 0.1%
211	2	< 0.1%

legal_name
Text

Distinct	3025
Distinct (%)	15.0%
Missing	0
Missing (%)	0.0%
Memory size	157.3 KiB

Length

Max length	67
Median length	46
Mean length	21.100418
Min length	4

Characters and Unicode

Total characters	424456
Distinct characters	78
Distinct categories	9 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	680 ?
Unique (%)	3.4%

Sample

1st row	THE LIFEWAY KEFIR SHOP LLC
2nd row	SQUARE KITCHEN, LLC
3rd row	Greek Prime Inc
4th row	GOMEZ RESTAURANT LLC
5th row	PLEASANT PIZZA, L.L.C.

Value	Count	Frequency (%)
inc	8857	12.9%
llc	6126	8.9%
corporation	1580	2.3%
restaurant	1296	1.9%
	1263	1.8%
starbucks	886	1.3%
chicago	882	1.3%
the	862	1.3%
corp	859	1.2%
cafe	705	1.0%
Other values (3620)	45488	66.1%

Most occurring characters

Value	Count	Frequency (%)
	48844	11.5%
C	30246	7.1%
I	29081	6.9%
A	28335	6.7%
N	27602	6.5%
L	26454	6.2%
O	25669	6.0%
R	25232	5.9%
E	24954	5.9%
T	20570	4.8%
Other values (68)	137469	32.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	333477	78.6%
Space Separator	48844	11.5%
Other Punctuation	26493	6.2%
Lowercase Letter	7883	1.9%
Decimal Number	6929	1.6%
Dash Punctuation	645	0.2%
Open Punctuation	85	< 0.1%
Close Punctuation	85	< 0.1%
Math Symbol	15	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
C	30246	9.1%
I	29081	8.7%
A	28335	8.5%
N	27602	8.3%
L	26454	7.9%
O	25669	7.7%
R	25232	7.6%
E	24954	7.5%
T	20570	6.2%
S	20233	6.1%
Other values (16)	75101	22.5%

Lowercase Letter

Value	Count	Frequency (%)
a	909	11.5%
e	905	11.5%
n	778	9.9%
o	653	8.3%
t	602	7.6%
r	591	7.5%
i	549	7.0%
s	513	6.5%
c	435	5.5%
l	353	4.5%
Other values (16)	1595	20.2%

Other Punctuation

Value	Count	Frequency (%)
.	11715	44.2%
,	11205	42.3%
'	2277	8.6%
&	1097	4.1%
#	92	0.3%
/	79	0.3%
"	18	0.1%
!	6	< 0.1%
@	2	< 0.1%
:	1	< 0.1%

Decimal Number

Value	Count	Frequency (%)
1	1325	19.1%
2	982	14.2%
0	893	12.9%
3	796	11.5%
5	795	11.5%
4	709	10.2%
8	465	6.7%
6	364	5.3%
7	356	5.1%
9	244	3.5%

Space Separator

Value	Count	Frequency (%)
	48844	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	645	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	85	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	85	100.0%

Math Symbol

Value	Count	Frequency (%)
+	15	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	341360	80.4%
Common	83096	19.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
C	30246	8.9%
I	29081	8.5%
A	28335	8.3%
N	27602	8.1%
L	26454	7.7%
O	25669	7.5%
R	25232	7.4%
E	24954	7.3%
T	20570	6.0%
S	20233	5.9%
Other values (42)	82984	24.3%

Common

Value	Count	Frequency (%)
	48844	58.8%
.	11715	14.1%
,	11205	13.5%
'	2277	2.7%
1	1325	1.6%
&	1097	1.3%
2	982	1.2%
0	893	1.1%
3	796	1.0%
5	795	1.0%
Other values (16)	3167	3.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	424456	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	48844	11.5%
C	30246	7.1%
I	29081	6.9%
A	28335	6.7%
N	27602	6.5%
L	26454	6.2%
O	25669	6.0%
R	25232	5.9%
E	24954	5.9%
T	20570	4.8%
Other values (68)	137469	32.4%

doing_business_as_name
Text

Distinct	3092
Distinct (%)	15.4%
Missing	0
Missing (%)	0.0%
Memory size	157.3 KiB

Length

Max length	88
Median length	45
Mean length	16.847882
Min length	1

Characters and Unicode

Total characters	338912
Distinct characters	77
Distinct categories	9 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	669 ?
Unique (%)	3.3%

Sample

1st row	LIFEWAY KEFIR SHOP
2nd row	FORK
3rd row	Greek Prime
4th row	DON PEPE
5th row	BOB'S PIZZA

Value	Count	Frequency (%)
	2393	4.3%
cafe	1444	2.6%
the	1373	2.5%
coffee	1313	2.3%
restaurant	1269	2.3%
bar	1209	2.2%
grill	1046	1.9%
starbucks	904	1.6%
inc	729	1.3%
and	636	1.1%
Other values (3513)	43590	78.0%

Most occurring characters

Value	Count	Frequency (%)
	35917	10.6%
A	27910	8.2%
E	25846	7.6%
R	20135	5.9%
O	19834	5.9%
S	19383	5.7%
I	17485	5.2%
T	17396	5.1%
N	16778	5.0%
C	14863	4.4%
Other values (67)	123365	36.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	268029	79.1%
Space Separator	35917	10.6%
Lowercase Letter	18888	5.6%
Other Punctuation	9372	2.8%
Decimal Number	6183	1.8%
Dash Punctuation	477	0.1%
Math Symbol	42	< 0.1%
Open Punctuation	2	< 0.1%
Close Punctuation	2	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	27910	10.4%
E	25846	9.6%
R	20135	7.5%
O	19834	7.4%
S	19383	7.2%
I	17485	6.5%
T	17396	6.5%
N	16778	6.3%
C	14863	5.5%
L	14449	5.4%
Other values (16)	73950	27.6%

Lowercase Letter

Value	Count	Frequency (%)
e	2391	12.7%
a	2308	12.2%
o	1514	8.0%
n	1499	7.9%
r	1377	7.3%
i	1364	7.2%
t	1155	6.1%
l	1110	5.9%
s	1080	5.7%
u	717	3.8%
Other values (15)	4373	23.2%

Other Punctuation

Value	Count	Frequency (%)
'	4093	43.7%
&	1842	19.7%
#	1296	13.8%
.	890	9.5%
,	579	6.2%
/	572	6.1%
"	46	0.5%
!	43	0.5%
@	8	0.1%
;	2	< 0.1%

Decimal Number

Value	Count	Frequency (%)
2	1496	24.2%
1	936	15.1%
4	653	10.6%
3	600	9.7%
5	597	9.7%
0	569	9.2%
7	390	6.3%
6	361	5.8%
9	293	4.7%
8	288	4.7%

Space Separator

Value	Count	Frequency (%)
	35917	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	477	100.0%

Math Symbol

Value	Count	Frequency (%)
+	42	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	2	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	286917	84.7%
Common	51995	15.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	27910	9.7%
E	25846	9.0%
R	20135	7.0%
O	19834	6.9%
S	19383	6.8%
I	17485	6.1%
T	17396	6.1%
N	16778	5.8%
C	14863	5.2%
L	14449	5.0%
Other values (41)	92838	32.4%

Common

Value	Count	Frequency (%)
	35917	69.1%
'	4093	7.9%
&	1842	3.5%
2	1496	2.9%
#	1296	2.5%
1	936	1.8%
.	890	1.7%
4	653	1.3%
3	600	1.2%
5	597	1.1%
Other values (16)	3675	7.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	338912	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	35917	10.6%
A	27910	8.2%
E	25846	7.6%
R	20135	5.9%
O	19834	5.9%
S	19383	5.7%
I	17485	5.2%
T	17396	5.1%
N	16778	5.0%
C	14863	4.4%
Other values (67)	123365	36.4%

issued_date
Date

Distinct	2997
Distinct (%)	14.9%
Missing	0
Missing (%)	0.0%
Memory size	157.3 KiB

Minimum	2001-03-14 00:00:00
Maximum	2023-10-18 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

expiration_date
Date

Distinct	28
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	157.3 KiB

Minimum	2001-11-01 00:00:00
Maximum	2024-02-29 00:00:00

Histogram

Histogram with fixed size bins (bins=28)

payment_date
Date

Distinct	2946
Distinct (%)	14.6%
Missing	0
Missing (%)	0.0%
Memory size	157.3 KiB

Minimum	2001-03-14 00:00:00
Maximum	2023-10-18 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

address
Text

Distinct	2575
Distinct (%)	12.8%
Missing	0
Missing (%)	0.0%
Memory size	157.3 KiB

Length

Max length	34
Median length	23
Mean length	16.682541
Min length	10

Characters and Unicode

Total characters	335586
Distinct characters	36
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	446 ?
Unique (%)	2.2%

Sample

1st row	0 W DIVISION ST
2nd row	4600 N LINCOLN AVE
3rd row	0 W 35TH ST
4th row	3616 W 26TH ST
5th row	1659 W 21ST ST

Value	Count	Frequency (%)
st	10459	12.9%
n	9115	11.2%
ave	8057	9.9%
w	7263	8.9%
e	1879	2.3%
s	1859	2.3%
0	1239	1.5%
clark	1189	1.5%
wells	1139	1.4%
lincoln	1043	1.3%
Other values (1881)	37932	46.7%

Most occurring characters

Value	Count	Frequency (%)
	61058	18.2%
E	21334	6.4%
S	21161	6.3%
A	20969	6.2%
N	20512	6.1%
T	16685	5.0%
1	12447	3.7%
L	12242	3.6%
I	11531	3.4%
W	11412	3.4%
Other values (26)	126235	37.6%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	206343	61.5%
Decimal Number	68185	20.3%
Space Separator	61058	18.2%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	21334	10.3%
S	21161	10.3%
A	20969	10.2%
N	20512	9.9%
T	16685	8.1%
L	12242	5.9%
I	11531	5.6%
W	11412	5.5%
R	10946	5.3%
O	10502	5.1%
Other values (15)	49049	23.8%

Decimal Number

Value	Count	Frequency (%)
1	12447	18.3%
0	10235	15.0%
2	8735	12.8%
3	8200	12.0%
5	7626	11.2%
4	6592	9.7%
6	4474	6.6%
7	4027	5.9%
8	3100	4.5%
9	2749	4.0%

Space Separator

Value	Count	Frequency (%)
	61058	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	206343	61.5%
Common	129243	38.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	21334	10.3%
S	21161	10.3%
A	20969	10.2%
N	20512	9.9%
T	16685	8.1%
L	12242	5.9%
I	11531	5.6%
W	11412	5.5%
R	10946	5.3%
O	10502	5.1%
Other values (15)	49049	23.8%

Common

Value	Count	Frequency (%)
	61058	47.2%
1	12447	9.6%
0	10235	7.9%
2	8735	6.8%
3	8200	6.3%
5	7626	5.9%
4	6592	5.1%
6	4474	3.5%
7	4027	3.1%
8	3100	2.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	335586	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	61058	18.2%
E	21334	6.4%
S	21161	6.3%
A	20969	6.2%
N	20512	6.1%
T	16685	5.0%
1	12447	3.7%
L	12242	3.6%
I	11531	3.4%
W	11412	3.4%
Other values (26)	126235	37.6%

address_number_start
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	1640
Distinct (%)	8.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1664.0896

Minimum	0
Maximum	11208
Zeros	1239
Zeros (%)	6.2%
Negative	0
Negative (%)	0.0%
Memory size	157.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	300
median	1235.5
Q3	2529
95-th percentile	4857
Maximum	11208
Range	11208
Interquartile range (IQR)	2229

Descriptive statistics

Standard deviation	1628.364
Coefficient of variation (CV)	0.97853146
Kurtosis	1.3921521
Mean	1664.0896
Median Absolute Deviation (MAD)	1033.5
Skewness	1.220232
Sum	33474826
Variance	2651569.3
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1239	6.2%
200	152	0.8%
1	106	0.5%
111	104	0.5%
2100	95	0.5%
20	91	0.5%
400	90	0.4%
175	86	0.4%
731	81	0.4%
2200	75	0.4%
Other values (1630)	17997	89.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1239	6.2%
1	106	0.5%
2	21	0.1%
5	17	0.1%
6	63	0.3%
7	7	< 0.1%
8	23	0.1%
9	17	0.1%
10	44	0.2%
11	9	< 0.1%

Value	Count	Frequency (%)
11208	1	< 0.1%
11057	1	< 0.1%
10701	10	< 0.1%
10533	2	< 0.1%
10448	1	< 0.1%
9710	1	< 0.1%
8753	1	< 0.1%
8548	9	< 0.1%
8301	1	< 0.1%
8300	1	< 0.1%

address_number
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	1640
Distinct (%)	8.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1664.0896

Minimum	0
Maximum	11208
Zeros	1239
Zeros (%)	6.2%
Negative	0
Negative (%)	0.0%
Memory size	157.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	300
median	1235.5
Q3	2529
95-th percentile	4857
Maximum	11208
Range	11208
Interquartile range (IQR)	2229

Descriptive statistics

Standard deviation	1628.364
Coefficient of variation (CV)	0.97853146
Kurtosis	1.3921521
Mean	1664.0896
Median Absolute Deviation (MAD)	1033.5
Skewness	1.220232
Sum	33474826
Variance	2651569.3
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1239	6.2%
200	152	0.8%
1	106	0.5%
111	104	0.5%
2100	95	0.5%
20	91	0.5%
400	90	0.4%
175	86	0.4%
731	81	0.4%
2200	75	0.4%
Other values (1630)	17997	89.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1239	6.2%
1	106	0.5%
2	21	0.1%
5	17	0.1%
6	63	0.3%
7	7	< 0.1%
8	23	0.1%
9	17	0.1%
10	44	0.2%
11	9	< 0.1%

Value	Count	Frequency (%)
11208	1	< 0.1%
11057	1	< 0.1%
10701	10	< 0.1%
10533	2	< 0.1%
10448	1	< 0.1%
9710	1	< 0.1%
8753	1	< 0.1%
8548	9	< 0.1%
8301	1	< 0.1%
8300	1	< 0.1%

street_direction
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	157.3 KiB

N	9115
W	7263
E	1879
S	1859

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	20116
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	W
2nd row	N
3rd row	W
4th row	W
5th row	W

Common Values

Value	Count	Frequency (%)
N	9115	45.3%
W	7263	36.1%
E	1879	9.3%
S	1859	9.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
n	9115	45.3%
w	7263	36.1%
e	1879	9.3%
s	1859	9.2%

Most occurring characters

Value	Count	Frequency (%)
N	9115	45.3%
W	7263	36.1%
E	1879	9.3%
S	1859	9.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	20116	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	9115	45.3%
W	7263	36.1%
E	1879	9.3%
S	1859	9.2%

Most occurring scripts

Value	Count	Frequency (%)
Latin	20116	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	9115	45.3%
W	7263	36.1%
E	1879	9.3%
S	1859	9.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	20116	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
N	9115	45.3%
W	7263	36.1%
E	1879	9.3%
S	1859	9.2%

street
Text

Distinct	228
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Memory size	157.3 KiB

Length

Max length	24
Median length	13
Mean length	6.8899384
Min length	3

Characters and Unicode

Total characters	138598
Distinct characters	35
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	24 ?
Unique (%)	0.1%

Sample

1st row	DIVISION
2nd row	LINCOLN
3rd row	35TH
4th row	26TH
5th row	21ST

Value	Count	Frequency (%)
clark	1189	5.7%
wells	1139	5.5%
lincoln	1043	5.0%
division	940	4.5%
michigan	729	3.5%
randolph	656	3.1%
southport	617	3.0%
milwaukee	599	2.9%
state	536	2.6%
halsted	501	2.4%
Other values (230)	12877	61.8%

Most occurring characters

Value	Count	Frequency (%)
A	12912	9.3%
L	11718	8.5%
I	11531	8.3%
E	11398	8.2%
N	11397	8.2%
O	10502	7.6%
R	10142	7.3%
S	8883	6.4%
T	6194	4.5%
D	6012	4.3%
Other values (25)	37909	27.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	136961	98.8%
Decimal Number	927	0.7%
Space Separator	710	0.5%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	12912	9.4%
L	11718	8.6%
I	11531	8.4%
E	11398	8.3%
N	11397	8.3%
O	10502	7.7%
R	10142	7.4%
S	8883	6.5%
T	6194	4.5%
D	6012	4.4%
Other values (15)	36272	26.5%

Decimal Number

Value	Count	Frequency (%)
3	310	33.4%
5	226	24.4%
1	143	15.4%
8	60	6.5%
6	56	6.0%
7	49	5.3%
2	44	4.7%
9	26	2.8%
4	13	1.4%

Space Separator

Value	Count	Frequency (%)
	710	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	136961	98.8%
Common	1637	1.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	12912	9.4%
L	11718	8.6%
I	11531	8.4%
E	11398	8.3%
N	11397	8.3%
O	10502	7.7%
R	10142	7.4%
S	8883	6.5%
T	6194	4.5%
D	6012	4.4%
Other values (15)	36272	26.5%

Common

Value	Count	Frequency (%)
	710	43.4%
3	310	18.9%
5	226	13.8%
1	143	8.7%
8	60	3.7%
6	56	3.4%
7	49	3.0%
2	44	2.7%
9	26	1.6%
4	13	0.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	138598	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	12912	9.3%
L	11718	8.5%
I	11531	8.3%
E	11398	8.2%
N	11397	8.2%
O	10502	7.6%
R	10142	7.3%
S	8883	6.4%
T	6194	4.5%
D	6012	4.3%
Other values (25)	37909	27.4%

street_type
Categorical

IMBALANCE

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	157.3 KiB

ST	10419
AVE	8057
RD	608
BLVD	269
PL	255
Other values (4)	508

Length

Max length	4
Median length	2
Mean length	2.4490952
Min length	2

Characters and Unicode

Total characters	49266
Distinct characters	15
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	ST
2nd row	AVE
3rd row	ST
4th row	ST
5th row	ST

Common Values

Value	Count	Frequency (%)
ST	10419	51.8%
AVE	8057	40.1%
RD	608	3.0%
BLVD	269	1.3%
PL	255	1.3%
PKWY	199	1.0%
DR	196	1.0%
CT	72	0.4%
HWY	41	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
st	10419	51.8%
ave	8057	40.1%
rd	608	3.0%
blvd	269	1.3%
pl	255	1.3%
pkwy	199	1.0%
dr	196	1.0%
ct	72	0.4%
hwy	41	0.2%

Most occurring characters

Value	Count	Frequency (%)
T	10491	21.3%
S	10419	21.1%
V	8326	16.9%
A	8057	16.4%
E	8057	16.4%
D	1073	2.2%
R	804	1.6%
L	524	1.1%
P	454	0.9%
B	269	0.5%
Other values (5)	792	1.6%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	49266	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
T	10491	21.3%
S	10419	21.1%
V	8326	16.9%
A	8057	16.4%
E	8057	16.4%
D	1073	2.2%
R	804	1.6%
L	524	1.1%
P	454	0.9%
B	269	0.5%
Other values (5)	792	1.6%

Most occurring scripts

Value	Count	Frequency (%)
Latin	49266	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
T	10491	21.3%
S	10419	21.1%
V	8326	16.9%
A	8057	16.4%
E	8057	16.4%
D	1073	2.2%
R	804	1.6%
L	524	1.1%
P	454	0.9%
B	269	0.5%
Other values (5)	792	1.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	49266	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
T	10491	21.3%
S	10419	21.1%
V	8326	16.9%
A	8057	16.4%
E	8057	16.4%
D	1073	2.2%
R	804	1.6%
L	524	1.1%
P	454	0.9%
B	269	0.5%
Other values (5)	792	1.6%

city
Categorical

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	157.3 KiB

CHICAGO	20116

Length

Max length	7
Median length	7
Mean length	7
Min length	7

Characters and Unicode

Total characters	140812
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	CHICAGO
2nd row	CHICAGO
3rd row	CHICAGO
4th row	CHICAGO
5th row	CHICAGO

Common Values

Value	Count	Frequency (%)
CHICAGO	20116	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
chicago	20116	100.0%

Most occurring characters

Value	Count	Frequency (%)
C	40232	28.6%
H	20116	14.3%
I	20116	14.3%
A	20116	14.3%
G	20116	14.3%
O	20116	14.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	140812	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
C	40232	28.6%
H	20116	14.3%
I	20116	14.3%
A	20116	14.3%
G	20116	14.3%
O	20116	14.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	140812	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
C	40232	28.6%
H	20116	14.3%
I	20116	14.3%
A	20116	14.3%
G	20116	14.3%
O	20116	14.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	140812	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
C	40232	28.6%
H	20116	14.3%
I	20116	14.3%
A	20116	14.3%
G	20116	14.3%
O	20116	14.3%

state
Categorical

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	157.3 KiB

IL	20116

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	40232
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	IL
2nd row	IL
3rd row	IL
4th row	IL
5th row	IL

Common Values

Value	Count	Frequency (%)
IL	20116	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
il	20116	100.0%

Most occurring characters

Value	Count	Frequency (%)
I	20116	50.0%
L	20116	50.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	40232	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
I	20116	50.0%
L	20116	50.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	40232	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
I	20116	50.0%
L	20116	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	40232	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
I	20116	50.0%
L	20116	50.0%

zip_code
Real number (ℝ)

Distinct	53
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	60625.512

Minimum	60601
Maximum	60707
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	157.3 KiB

Quantile statistics

Minimum	60601
5-th percentile	60602
Q1	60610
median	60618
Q3	60647
95-th percentile	60657
Maximum	60707
Range	106
Interquartile range (IQR)	37

Descriptive statistics

Standard deviation	19.888896
Coefficient of variation (CV)	0.0003280615
Kurtosis	-0.68234855
Mean	60625.512
Median Absolute Deviation (MAD)	11
Skewness	0.70032352
Sum	1.2195428 × 10⁹
Variance	395.56819
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
60611	1840	9.1%
60654	1768	8.8%
60622	1723	8.6%
60614	1551	7.7%
60657	1420	7.1%
60607	1156	5.7%
60613	981	4.9%
60610	948	4.7%
60647	883	4.4%
60618	835	4.2%
Other values (43)	7011	34.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
60601	652	3.2%
60602	410	2.0%
60603	330	1.6%
60604	234	1.2%
60605	729	3.6%
60606	385	1.9%
60607	1156	5.7%
60608	207	1.0%
60609	31	0.2%
60610	948	4.7%

Value	Count	Frequency (%)
60707	47	0.2%
60661	504	2.5%
60660	199	1.0%
60659	189	0.9%
60657	1420	7.1%
60656	15	0.1%
60655	3	< 0.1%
60654	1768	8.8%
60653	20	0.1%
60651	3	< 0.1%

ward
Real number (ℝ)

HIGH CORRELATION

Distinct	44
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	31.484192

Minimum	1
Maximum	50
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	157.3 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	26
median	42
Q3	43
95-th percentile	47
Maximum	50
Range	49
Interquartile range (IQR)	17

Descriptive statistics

Standard deviation	16.404843
Coefficient of variation (CV)	0.52105015
Kurtosis	-0.67601154
Mean	31.484192
Median Absolute Deviation (MAD)	5
Skewness	-0.9521053
Sum	633336
Variance	269.11887
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=44)

Value	Count	Frequency (%)
42	5554	27.6%
1	1579	7.8%
27	1537	7.6%
47	1476	7.3%
44	1427	7.1%
2	1374	6.8%
43	1187	5.9%
32	1114	5.5%
4	666	3.3%
25	471	2.3%
Other values (34)	3731	18.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1579	7.8%
2	1374	6.8%
3	289	1.4%
4	666	3.3%
5	103	0.5%
6	1	< 0.1%
8	2	< 0.1%
9	1	< 0.1%
10	13	0.1%
11	331	1.6%

Value	Count	Frequency (%)
50	104	0.5%
49	148	0.7%
48	361	1.8%
47	1476	7.3%
46	335	1.7%
45	238	1.2%
44	1427	7.1%
43	1187	5.9%
42	5554	27.6%
41	81	0.4%

police_district
Real number (ℝ)

HIGH CORRELATION

Distinct	23
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	13.841072

Minimum	0
Maximum	25
Zeros	4
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	157.3 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	12
median	18
Q3	19
95-th percentile	20
Maximum	25
Range	25
Interquartile range (IQR)	7

Descriptive statistics

Standard deviation	6.8661682
Coefficient of variation (CV)	0.496072
Kurtosis	-0.40058466
Mean	13.841072
Median Absolute Deviation (MAD)	2
Skewness	-1.0016119
Sum	278427
Variance	47.144266
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=23)

Value	Count	Frequency (%)
18	5337	26.5%
19	4255	21.2%
1	3656	18.2%
12	2388	11.9%
14	1788	8.9%
20	760	3.8%
16	418	2.1%
17	373	1.9%
24	309	1.5%
2	237	1.2%
Other values (13)	595	3.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4	< 0.1%
1	3656	18.2%
2	237	1.2%
3	10	< 0.1%
4	15	0.1%
5	1	< 0.1%
6	2	< 0.1%
7	1	< 0.1%
8	44	0.2%
9	223	1.1%

Value	Count	Frequency (%)
25	149	0.7%
24	309	1.5%
22	27	0.1%
20	760	3.8%
19	4255	21.2%
18	5337	26.5%
17	373	1.9%
16	418	2.1%
15	7	< 0.1%
14	1788	8.9%

latitude
Real number (ℝ)

HIGH CORRELATION

Distinct	2567
Distinct (%)	12.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	41.910374

Minimum	41.69067
Maximum	42.019421
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	157.3 KiB

Quantile statistics

Minimum	41.69067
5-th percentile	41.865345
Q1	41.885257
median	41.902442
Q3	41.939257
95-th percentile	41.978062
Maximum	42.019421
Range	0.32875146
Interquartile range (IQR)	0.053999362

Descriptive statistics

Standard deviation	0.037932607
Coefficient of variation (CV)	0.00090508872
Kurtosis	1.7970222
Mean	41.910374
Median Absolute Deviation (MAD)	0.020466559
Skewness	-0.10651859
Sum	843069.08
Variance	0.0014388826
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
41.88200199	98	0.5%
41.88197573	96	0.5%
41.90405052	85	0.4%
41.87801449	81	0.4%
41.88460018	69	0.3%
41.8825402	53	0.3%
41.90186736	40	0.2%
41.89678605	40	0.2%
41.88216417	37	0.2%
41.87949547	37	0.2%
Other values (2557)	19480	96.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
41.69066951	1	< 0.1%
41.69139989	2	< 0.1%
41.69245222	1	< 0.1%
41.69920305	10	< 0.1%
41.70289718	1	< 0.1%
41.70356373	2	< 0.1%
41.71874411	1	< 0.1%
41.72107515	10	< 0.1%
41.72112515	1	< 0.1%
41.72177014	1	< 0.1%

Value	Count	Frequency (%)
42.01942097	12	0.1%
42.0193885	5	< 0.1%
42.01934594	4	< 0.1%
42.01933013	3	< 0.1%
42.01932963	2	< 0.1%
42.0193098	4	< 0.1%
42.01927235	1	< 0.1%
42.0174068	8	< 0.1%
42.01615704	15	0.1%
42.01615267	15	0.1%

longitude
Real number (ℝ)

HIGH CORRELATION

Distinct	2567
Distinct (%)	12.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-87.6553

Minimum	-87.834308
Maximum	-87.535139
Zeros	0
Zeros (%)	0.0%
Negative	20116
Negative (%)	100.0%
Memory size	157.3 KiB

Quantile statistics

Minimum	-87.834308
5-th percentile	-87.709805
Q1	-87.672586
median	-87.648962
Q3	-87.629547
95-th percentile	-87.624223
Maximum	-87.535139
Range	0.29916895
Interquartile range (IQR)	0.043038819

Descriptive statistics

Standard deviation	0.03338854
Coefficient of variation (CV)	-0.00038090726
Kurtosis	5.12465
Mean	-87.6553
Median Absolute Deviation (MAD)	0.020372619
Skewness	-1.7591978
Sum	-1763274
Variance	0.0011147946
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-87.63103164	98	0.5%
-87.63397185	96	0.5%
-87.62874675	85	0.4%
-87.63318903	81	0.4%
-87.62798897	69	0.3%
-87.62453095	53	0.3%
-87.62849214	40	0.2%
-87.62828088	40	0.2%
-87.62451427	37	0.2%
-87.63382966	37	0.2%
Other values (2557)	19480	96.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-87.8343079	1	< 0.1%
-87.82625503	9	< 0.1%
-87.82618448	1	< 0.1%
-87.82167425	5	< 0.1%
-87.82042719	4	< 0.1%
-87.81865423	16	0.1%
-87.81795264	4	< 0.1%
-87.81783297	3	< 0.1%
-87.81729036	11	0.1%
-87.8172596	1	< 0.1%

Value	Count	Frequency (%)
-87.53513895	2	< 0.1%
-87.55117213	1	< 0.1%
-87.55124869	1	< 0.1%
-87.55161886	9	< 0.1%
-87.56729719	2	< 0.1%
-87.58184369	4	< 0.1%
-87.58390766	1	< 0.1%
-87.58502961	2	< 0.1%
-87.58781452	8	< 0.1%
-87.58797399	7	< 0.1%

location
Text

Distinct	2567
Distinct (%)	12.8%
Missing	0
Missing (%)	0.0%
Memory size	157.3 KiB

Length

Max length	40
Median length	39
Mean length	39.105538
Min length	35

Characters and Unicode

Total characters	786647
Distinct characters	16
Distinct categories	6 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	445 ?
Unique (%)	2.2%

Sample

1st row	(41.90405051948726, -87.62874675447662)
2nd row	(41.964902360748326, -87.68627917084095)
3rd row	(41.831121574889146, -87.62670680090584)
4th row	(41.844483527070835, -87.71558453559561)
5th row	(41.853999857174315, -87.66845450091006)

Value	Count	Frequency (%)
41.88200198545344	98	0.2%
87.6310316367502	98	0.2%
41.881975727713886	96	0.2%
87.63397184627037	96	0.2%
41.90405051948726	85	0.2%
87.62874675447662	85	0.2%
41.878014487249544	81	0.2%
87.63318903001444	81	0.2%
87.62798896732363	69	0.2%
41.884600177780484	69	0.2%
Other values (5124)	39374	97.9%

Most occurring characters

Value	Count	Frequency (%)
8	84465	10.7%
4	75171	9.6%
7	74161	9.4%
6	72016	9.2%
1	70017	8.9%
9	62712	8.0%
2	53703	6.8%
3	53206	6.8%
5	52647	6.7%
0	47737	6.1%
Other values (6)	140812	17.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	645835	82.1%
Other Punctuation	60348	7.7%
Open Punctuation	20116	2.6%
Space Separator	20116	2.6%
Dash Punctuation	20116	2.6%
Close Punctuation	20116	2.6%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
8	84465	13.1%
4	75171	11.6%
7	74161	11.5%
6	72016	11.2%
1	70017	10.8%
9	62712	9.7%
2	53703	8.3%
3	53206	8.2%
5	52647	8.2%
0	47737	7.4%

Other Punctuation

Value	Count	Frequency (%)
.	40232	66.7%
,	20116	33.3%

Open Punctuation

Value	Count	Frequency (%)
(	20116	100.0%

Space Separator

Value	Count	Frequency (%)
	20116	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	20116	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	20116	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	786647	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
8	84465	10.7%
4	75171	9.6%
7	74161	9.4%
6	72016	9.2%
1	70017	8.9%
9	62712	8.0%
2	53703	6.8%
3	53206	6.8%
5	52647	6.7%
0	47737	6.1%
Other values (6)	140812	17.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	786647	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
8	84465	10.7%
4	75171	9.6%
7	74161	9.4%
6	72016	9.2%
1	70017	8.9%
9	62712	8.0%
2	53703	6.8%
3	53206	6.8%
5	52647	6.7%
0	47737	6.1%
Other values (6)	140812	17.9%

Auto

Heatmap
Table

	permit_number	account_number	site_number	address_number_start	address_number	zip_code	ward	police_district	latitude	longitude	street_direction	street_type
permit_number	1.000	0.473	0.017	-0.174	-0.174	-0.018	-0.082	-0.156	-0.143	0.039	0.037	0.041
account_number	0.473	1.000	-0.174	-0.123	-0.123	-0.046	-0.108	-0.158	-0.136	0.021	0.075	0.067
site_number	0.017	-0.174	1.000	-0.122	-0.122	-0.097	0.075	-0.051	-0.074	0.144	0.069	0.054
address_number_start	-0.174	-0.123	-0.122	1.000	1.000	0.378	0.176	0.513	0.707	-0.744	0.294	0.210
address_number	-0.174	-0.123	-0.122	1.000	1.000	0.378	0.176	0.513	0.707	-0.744	0.294	0.210
zip_code	-0.018	-0.046	-0.097	0.378	0.378	1.000	0.177	0.452	0.450	-0.476	0.307	0.222
ward	-0.082	-0.108	0.075	0.176	0.176	0.177	1.000	0.510	0.453	-0.049	0.286	0.167
police_district	-0.156	-0.158	-0.051	0.513	0.513	0.452	0.510	1.000	0.813	-0.339	0.383	0.186
latitude	-0.143	-0.136	-0.074	0.707	0.707	0.450	0.453	0.813	1.000	-0.633	0.385	0.212
longitude	0.039	0.021	0.144	-0.744	-0.744	-0.476	-0.049	-0.339	-0.633	1.000	0.321	0.268
street_direction	0.037	0.075	0.069	0.294	0.294	0.307	0.286	0.383	0.385	0.321	1.000	0.241
street_type	0.041	0.067	0.054	0.210	0.210	0.222	0.167	0.186	0.212	0.268	0.241	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	permit_number	account_number	site_number	legal_name	doing_business_as_name	issued_date	expiration_date	payment_date	address	address_number_start	address_number	street_direction	street	street_type	city	state	zip_code	ward	police_district	latitude	longitude	location
0	1556602	328992	1	THE LIFEWAY KEFIR SHOP LLC	LIFEWAY KEFIR SHOP	07/16/2021	02/28/2022	07/16/2021	0 W DIVISION ST	0	0	W	DIVISION	ST	CHICAGO	IL	60622.0	1	18.0	41.904051	-87.628747	(41.90405051948726, -87.62874675447662)
1	1534556	252742	1	SQUARE KITCHEN, LLC	FORK	07/16/2021	02/28/2022	07/16/2021	4600 N LINCOLN AVE	4600	4600	N	LINCOLN	AVE	CHICAGO	IL	60625.0	47	19.0	41.964902	-87.686279	(41.964902360748326, -87.68627917084095)
2	1536276	475114	1	Greek Prime Inc	Greek Prime	07/19/2021	02/28/2022	07/19/2021	0 W 35TH ST	0	0	W	35TH	ST	CHICAGO	IL	60609.0	11	2.0	41.831122	-87.626707	(41.831121574889146, -87.62670680090584)
3	1548240	369667	1	GOMEZ RESTAURANT LLC	DON PEPE	07/20/2021	02/28/2022	07/20/2021	3616 W 26TH ST	3616	3616	W	26TH	ST	CHICAGO	IL	60623.0	22	10.0	41.844484	-87.715585	(41.844483527070835, -87.71558453559561)
4	1531318	431422	1	PLEASANT PIZZA, L.L.C.	BOB'S PIZZA	07/23/2021	02/28/2022	07/23/2021	1659 W 21ST ST	1659	1659	W	21ST	ST	CHICAGO	IL	60608.0	25	12.0	41.854000	-87.668455	(41.853999857174315, -87.66845450091006)
5	1533842	457992	1	MIR - MUR, INC.,	The Great American Bagel	07/23/2021	02/28/2022	07/23/2021	1154 W MADISON ST	1154	1154	W	MADISON	ST	CHICAGO	IL	60607.0	25	12.0	41.881737	-87.656547	(41.88173703022226, -87.65654694665614)
6	1538898	317383	1	AJD RESTAURANT GROUP, LLC	SULLY'S HOUSE	07/23/2021	02/28/2022	07/22/2021	1501 N DAYTON ST	1501	1501	N	DAYTON	ST	CHICAGO	IL	60642.0	2	18.0	41.908620	-87.649295	(41.90861972732258, -87.64929457094323)
7	1533848	398305	3	ROANOKE HOSPITALITY, LLC	ROANOKE	12/10/2021	02/28/2022	06/14/2021	135 W MADISON ST	135	135	W	MADISON	ST	CHICAGO	IL	60602.0	42	1.0	41.881857	-87.631896	(41.88185674363783, -87.63189616155178)
8	1148396	469791	1	EL CHUZO, INC.	SAUGANASH GRILL	12/13/2021	02/28/2022	04/19/2021	6005 N SAUGANASH AVE	6005	6005	N	SAUGANASH	AVE	CHICAGO	IL	60646.0	39	17.0	41.990266	-87.732997	(41.990266341555525, -87.73299734383897)
9	1548849	211324	1	ITALIAN RISTORANTE-HUBBARD, LLC	VERMILION	12/18/2021	02/28/2022	12/18/2021	10 W HUBBARD ST	10	10	W	HUBBARD	ST	CHICAGO	IL	60654.0	42	18.0	41.890169	-87.628394	(41.89016858549094, -87.62839433601951)

	permit_number	account_number	site_number	legal_name	doing_business_as_name	issued_date	expiration_date	payment_date	address	address_number_start	address_number	street_direction	street	street_type	city	state	zip_code	ward	police_district	latitude	longitude	location
20106	1813353	493688	1	THE UNDERSTUDY COFFEE AND BOOKS, LLC	THE UNDERSTUDY COFFEE AND BOOKS	06/15/2023	02/29/2024	06/15/2023	5531 N CLARK ST	5531	5531	N	CLARK	ST	CHICAGO	IL	60640.0	48	20.0	41.982613	-87.668426	(41.982613033865064, -87.66842628885883)
20107	1826782	15848	1	FIGUEROA BAR, INC.	DAMEN TAVERN	06/13/2023	02/29/2024	06/13/2023	1958 W HURON ST	1958	1958	W	HURON	ST	CHICAGO	IL	60622.0	36	12.0	41.894205	-87.676882	(41.89420534591261, -87.67688170620728)
20108	1828623	478579	1	CAFE SOPHIE GOLD COAST LLC	Cafe Sophie	06/15/2023	02/29/2024	06/15/2023	0 N STATE ST	0	0	N	STATE	ST	CHICAGO	IL	60610.0	42	1.0	41.882083	-87.627964	(41.882082751743674, -87.62796364640772)
20109	1805612	493069	1	BUCKTOWN BBQ, INC.	FIREWOOD BBQ	06/21/2023	02/29/2024	06/21/2023	1600 W NORTH AVE	1600	1600	W	NORTH	AVE	CHICAGO	IL	60622.0	32	14.0	41.910739	-87.667756	(41.91073912357612, -87.66775554223523)
20110	1823617	468560	1	BUREAU BAR AND RESTAURANT LLC	BUREAU BAR AND RESTAURANT	06/21/2023	02/29/2024	06/21/2023	0 S STATE ST	0	0	S	STATE	ST	CHICAGO	IL	60616.0	3	1.0	41.881960	-87.627937	(41.881960316026536, -87.6279372789252)
20111	1809045	486915	1	River North Egg Harbor, LLC	Egg Harbor Cafe	06/21/2023	02/29/2024	06/21/2023	800 N WELLS ST	800	800	N	WELLS	ST	CHICAGO	IL	60610.0	27	18.0	41.896634	-87.634351	(41.8966337490024, -87.63435133722824)
20112	1816017	490229	1	LA ESQUINA DEL TACO INC.,	LA ESQUINA DEL TACO	06/21/2023	02/29/2024	06/21/2023	3259 W 63RD ST	3259	3259	W	63RD	ST	CHICAGO	IL	60629.0	14	8.0	41.778828	-87.705434	(41.77882757627881, -87.70543426650146)
20113	1815670	294329	1	RICHMOND TAVERN, INC.	RICHMOND TAVERN	06/27/2023	02/29/2024	06/27/2023	2944 W GRAND AVE	2944	2944	W	GRAND	AVE	CHICAGO	IL	60622.0	36	12.0	41.896089	-87.700748	(41.89608917059594, -87.70074823336402)
20114	1815487	486699	1	CASA AMIGOS RESTAURANT BAR LLC	LOS MOLCAJETES RESTAURANT BAR	06/27/2023	02/29/2024	06/27/2023	3830 W LAWRENCE AVE	3830	3830	W	LAWRENCE	AVE	CHICAGO	IL	60625.0	35	17.0	41.968390	-87.724448	(41.968390431264375, -87.72444785924317)
20115	1834781	463188	1	ETTA RIVER NORTH, LLC	ETTA	06/27/2023	02/29/2024	06/27/2023	0 N CLARK ST	0	0	N	CLARK	ST	CHICAGO	IL	60654.0	42	1.0	41.882002	-87.631032	(41.88200198545344, -87.6310316367502)

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Lowercase Letter

Other Punctuation

Decimal Number

Space Separator

Dash Punctuation

Open Punctuation

Close Punctuation

Math Symbol

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Lowercase Letter

Other Punctuation

Decimal Number

Space Separator

Dash Punctuation

Math Symbol

Open Punctuation

Close Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values